Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BACKUP_CORRUPTION

`V$BACKUP_CORRUPTION` displays information about corrupt block ranges in datafile backups from the control file. Note that corruptions are not tolerated in the control file and archived redo log backups.

Column | Datatype | Description
--- | --- | ---
`RECID` | `NUMBER` | Backup corruption record ID
`STAMP` | `NUMBER` | Backup corruption record stamp
`SET_STAMP` | `NUMBER` | Backup set stamp
`SET_COUNT` | `NUMBER` | Backup set count
`PIECE#` | `NUMBER` | backup piece that contains this corrupt block
`FILE#` | `NUMBER` | Absolute file number of the datafile that contains the corrupt blocks
`BLOCK#` | `NUMBER` | Block number of the first corrupt block in the range of corrupted blocks
`BLOCKS` | `NUMBER` | Number of corrupted blocks found starting with `BLOCK#`
`CORRUPTION_CHANGE#` | `NUMBER` | Change number at which the logical corruption was detected. Set to 0 to indicate media corruption.
`MARKED_CORRUPT` | `VARCHAR2(3)` | Indicates whether this corruption was not previously detected by the Oracle Database (`YES`) or the Oracle Database had already discovered this corrupt block and marked it as corrupt (`NO`). Note that when a corrupt block is encountered in a backup, and was not already marked corrupt by the Oracle Database, then the backup process does not mark the block as corrupt in the production datafile. Thus, this field may be `YES` for the same block in more than one backup set.
`CORRUPTION_TYPE` | `VARCHAR2(9)` | Type of block corruption in the datafile: `ALL ZERO` - Block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block. `FRACTURED` - Block header looks reasonable, but the front and back of the block are different versions. `CHECKSUM` - optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it probably fails because sectors in the middle of the block are from different versions. `CORRUPT` - Block is wrongly identified or is not a data block (for example, the data block address is missing) `LOGICAL` - Specifies the range is for logically corrupt blocks. `CORRUPTION_CHANGE#` will have a nonzero value.